Adding a New Customer
Checking the Added Customer - tblCUSTOMER
Customer Organization - tblORGANIZATION
Customer Type - tblCUSTOMERTYPE
Computed Column
Placing a New Order
Checking Products - tblPRODUCT
Tracking orders – tblORDER
Employee Information - tblEMPLOYEE
Computed Column
Business Rule: Delivery
Service is only
available to Customers in
WA & CA
Executing a stored procedure with illegal data
Adding New Livestock
Livestock Type
Livestock Information
Computed Column
Business Rule: No
Milking of Cows
younger than 12
months
Tracking Activities
On Farm - tblEVENT
Tracking Who Did What and When – tblEMPLOYEE_EVENT